<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
	$localHomeLink="index.php?id=organisateur_liste_organisateurs";
?>
<h3 align="center">Ajout d'un organisateur</h3>

<form action="<?php echo $localHomeLink; ?>" method="post">
	<table style="width: 50%; margin: 10px auto 30px auto;">
		<tr>
			<td class="palette palette-firm">Pseudo</td>
			<td>
				<select name="pseudo">
				<?php 	  
					$vSql = "SELECT pseudo FROM membre ";
					$vQuery = pg_query($oSql, $vSql);
					while($vResult = pg_fetch_array($vQuery))
					{
						echo '<option value="'.$vResult['pseudo'].'">'.$vResult['pseudo'].'</option>';
					}
				 ?>
				</select>
			</td>
		</tr>
		<tr>
			<td class="palette palette-firm">Edition</td>
			<td>
				<select name="edition">
				<?php 	  
					$vSql2 = "SELECT edition FROM tournoi ";
					$vQuery2 = pg_query($oSql, $vSql2);
					while($vResult2 = pg_fetch_array($vQuery2))
					{
						echo '<option value="'.$vResult2['edition'].'">'.$vResult2['edition'].'</option>';
					}
				 ?>
				</select>
			</td>
		</tr>
		<tr>
			<td class="palette palette-firm">Role</td>
			<td><input type="text" name='role'/></td>
		</tr>
		<tr>
			<td style="text-align: center;" colspan="2"><input type="submit" value="Valider"></td>
		</tr>
	</table>
	<input type="hidden" name='add' value='1'/>
</form>
